1)SEE THE COLUMN IN A TABLE
exec sys.sp_columns tablename
To see Entire Columns in the DB
select * from INFORMATION_SCHEMA.COLUMNS
and
select *from sys.all_columns
2)SEE THE DATABASES IN SERVER
EXEC sys.sp_databases
3)SEE THE DETAILS ABOUT TABLE/VIEW
sys.sp_help tablename/viewname
4)SEE THE DETAILS ABOUT VIEWS
sys.sp_helptext viewname
No comments:
Post a Comment