Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

sp_columns

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 10, rows affected: 0, absolute service time: 0,19 sec 
edit mode |  history
   name system_type_id name precision name
1 t 99 ntext 0 deleteTable
2 v 231 nvarchar 0 deleteTable
3 v 231 sysname 0 deleteTable
   TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME PRECISION LENGTH SCALE RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SS_DATA_TYPE
1 rextester dbo deleteTable v -10 ntext 1073741823 2147483646 NULL NULL 1 NULL NULL -10 NULL 2147483646 1 YES 39
2 rextester dbo deleteTable t -10 ntext 1073741823 2147483646 NULL NULL 1 NULL NULL -10 NULL 2147483646 2 YES 35