SQL နဲ႔ ပါတ္သက္ျပီး အျမဲသံုးေနၾက မဟုတ္တဲ႔ code ေတြကို လိုရင္ ျပန္သံုးလို႔ ရေအာင္ ဒီမွာပဲ မွတ္ထားလိုက္ေတာ့မယ္။
table field(column) ေလးတစ္ခုကို ကိုယ့္ database ၾကီး တစ္ခုလံုးထဲမွာ ရွိတဲ႔ ဘယ္ table ေတြမွာ ေခၚသံုးထားလဲ သိခ်င္ရင္.....
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%Case_ID%'
ORDER BY schema_name, table_name;
ကိုယ့္ database ၾကီး တစ္ခုလံုးထဲမွာရွိတဲ႔ table တစ္ခုစီရဲ႕ records(row) အေရအတြက္ကို သိခ်င္ရင္.....
SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
FROM sys.dm_db_partition_stats st
WHERE index_id < 2
ORDER BY st.row_count DESC
ကိုယ့္ database ၾကီး တစ္ခုလံုးထဲမွာရွိတဲ႔ table တစ္ခုစီရဲ႕ field(columns) name ေတြကို သိခ်င္ရင္.....
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
ORDER BY schema_name, table_name;