Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL server table information (Read 1660 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL server table information
28.10.09 at 11:02:44
 
SQL server table information
 
Table information in a SQL Server database can be retrieved by querying the sys.tables table.  
 
Using SQL*XL query: select * from sys.tables
 
Column information can be retrieved from sys.all_columns.  The object_id column can be used to join to the tables table.
 
Information about column data types can be found in the sys.types table. Use the column user_type_id to join to all_columns.system_type_id or to all_columns.user_type_id if it is a user type.
Back to top
 
« Last Edit: 28.10.09 at 11:12:30 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1