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

SQL Server - View Table Metadata

Language: Layout:
View schema
Execution time: 0,08 sec, rows selected: 7, rows affected: 0, absolute service time: 0,25 sec, absolute service time: 0,25 sec 
edit mode |  history
   object_id schema_name table_name column_id column_name is_nullable data_type max_length precision scale
1 544798116 dbo customer_invoices 1 invoice_id False int 4 10 0
2 544798116 dbo customer_invoices 2 invoice_customer_id False int 4 10 0
3 544798116 dbo customer_invoices 3 invoice_amount True decimal 9 19 4
4 512798002 dbo customers 1 customer_id False int 4 10 0
5 512798002 dbo customers 2 customer_name True varchar 100 0 0
6 512798002 dbo customers 3 customer_invoice_rate True decimal 5 3 2
7 512798002 dbo customers 4 customer_vat_rate True decimal 5 3 2