Get table structure using SQL query in SQL Server
Here it s the query for retrieve the table structure in sql server,
WHERE TABLE_NAME='table Name'
SELECT Ordinal_Position,Column_Name,Data_Type,Is_Nullable,Character_Maximum_Length
INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='table Name'
Comments
Post a Comment