Hello Everybody, Please help me out:
Is there a system stored procedure for retrieving the sql statement that created a table.
I know i can use sp_helptext for views etc; i want the equivalent for tables.
sp_columns is not adequate either.
please help! thanks in advance;)sp_help will return all the columns of a table.|||sp_help will return all the columns of a table.
Hi Blindman,
I ran exec sp_help tblcustomers and i got:
Name: tblcustomers
Owner: dbo
Type: user table
Created_datetime: 4/18/2007 2:26:12 PM
Am i missing something??
No comments:
Post a Comment