Thursday, November 11, 2010

Check Existence of Column In Table SQL SERVER

SELECT Name FROM sys.all_columns WHERE
[object_id] =OBJECT_ID(N'dbo.TableName') AND NAME = 'ColumnName'


SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName'
AND COLUMN_NAME = 'YourColumnName'
-
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...

  • Apply Criteria on XPCollection
    CriteriaOperator criteria = new BinaryOperator("Age", 30, BinaryOperatorType.Greater); CriteriaOperator criteria = CriteriaOperato...
  • How To Sort a XPCollection
    SortingCollection sc = new SortingCollection(); sc.Add (new SortProperty("field on which you want to sort",DevExpress.Xpo.DB.Sorti...
  • Angular Build Minification and Uglification
    Minification and Uglyfication in Angular Deployement Minification : While building Angular Application white spaces , unused variable , u...