Archive for December 28th, 2007
How Compilers Work?
Posted December 28, 2007
on:- In: SQL | SQL Server
- Leave a Comment
1. Following Query displays all the table names.
Query : select name from sys.objects where type=‘u’ ;
2. Following Query displays all the columns in a table
Query : select Table_Name,Column_Name from INFORMATION_SCHEMA.COLUMNS ;