SQL Database
Kept all necessary SQL in day to day works.
Wednesday, March 26, 2014
MSSQL: Does the column exits in a table
select * from sys.columns
where
Name = N'[column name]'
and Object_ID = Object_ID(N'[Table Name]')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment