select col.name as 'ColumName',typ.name as 'DataType' from sys.columns col left join sys.types typ
on col.system_type_id=typ.system_type_id where object_id=object_id('login')
That will show you the result as below:
Friday 7 June 2013
How to find Column Name and it's Data Type in Sql Server
Following will show you the column list with their datatype of a table in SQL Server.
That will show you the result as below:
That will show you the result as below:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment