DEFINITIONS

Definitions More Info.
Definition ID811
TitlePOSTGRESQL
CategoryNOTES
DefinitionFind column names,types,with table name
Definition Description-- Kolon adları, data tipleri, ve tablo adlarını bir arada görürsün.

SELECT
column_name,
data_type,
table_name
FROM
information_schema.columns
WHERE
column_name = 'OrderNo'
AND data_type = 'unknown'
ORDER BY
table_name DESC
RecordBycunay
Record Date18-10-2017 09:14:09
Düzenle
Kopyala
Sil