Friday, June 11, 2010

Find all Database in sql server 2005

select * from sys.databases


select * from sys.tables



To see all the column of table



select * from sys.all_columns where [object_id]= OBJECT_ID (N'dbo.emp')//Emp is table name
 
-
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...