Results 1 to 4 of 4

Thread: Tables

  1. #1
    Database Junkie Guest

    Default Tables

    Hey i would to know the command to delete a table, and create a table, and a method/command to get all the table names on a screen.<BR><BR>Please Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Tables<BR><BR><BR><BR>R&D ADO for field names, and the SQL Drop Table statement.

  3. #3
    Join Date
    Dec 1969

    Default Depends.....

    Are you working with SQL Server or Access?<BR><BR>SQl Server:<BR><BR>//Delete a table<BR>Delete from Tablename<BR>Drop Table TableName (table must be empty before can be dropped)<BR><BR>//Create a new table<BR>Create Table tablename<BR>(field1 int identity, field2 nvarchar (50), etc.)<BR>go<BR><BR>//Get all table names<BR>Select Name from SysObjects Where Xtype = 1<BR>Not sure if xtype = 1 is correct, you&#039;ll have to look that one up!<BR><BR>HTH<BR>Dave

  4. #4
    Database Junkie Guest

    Default Access 97


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts