테이블 칼럼명 구하기. 기타 등등

1.

SELECT table_name=sysobjects.name,
         column_name=syscolumns.name,
         datatype=systypes.name,
         length=syscolumns.length
    FROM sysobjects 
    JOIN syscolumns ON sysobjects.id = syscolumns.id
    JOIN systypes ON syscolumns.xtype=systypes.xtype
   WHERE sysobjects.xtype='U'
ORDER BY sysobjects.name,syscolumns.colid

 

2. SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'Foo' 

 

3. SELECT count(*) FROM <table_name>

 

4. SELECT count(*) FROM <table_name> where <field_name> is null

 

5. SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = <table_name> 

 

6. SELECT * from <table_name>

 

7. delete from <table_name>

 

8.  drop table <table_name>

 

9. select * from MSDB.dbo.sysjobhistory   ///Get reasons of job failure of SQL Agent jobs

 

10. select column_name ‘Column Name’, 

               data_type ‘Data Type’,

               character_maximum_length ‘Maximum Length'

    from information_schema.columns

    where table_name = ‘table_name’