Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

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






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development